Q Week 6: Compensation Plan Proposal (Excellence System) Note: This assignment is a part of the Excellence System and fulfills the Analysis and Problem Solving competency. As you know, you are the newly hired HR Manager for Columbus Custom Carpentry (CCC). Our CEO, Anthony Cooney, asked you to prepare a preliminary report regarding the compensation structure for the Warehouse and Manufacturing Departments. You conducted a job analysis and outlined the revisions you proposed in your Week 4 preliminary memo. Now you need to turn that preliminary report into a specific proposal regarding pay for the employees in these 2 departments. You should consider all of the materials you have already been using, along with the job value analysis you prepared, including the external market data provided to you in the CCC spreadsheet. Employee Handbook Columbus Custom Carpentry Case Study Columbus Custom Carpentry Employee Spreadsheet Job Value Worksheet Current job descriptions Access to the company’s HRIS system containing important employee information, including current pay Access to key employees who will discuss what they think the problems are Outside research is not necessary for this assignment. All othe necessary resources are provided to you. Using the template provided below, prepare a comprehensive final report and proposal that includes the following sections: Introduction and brief summary of problem to be solved. 1. Relevant facts and data that will put the problem and your proposed solution into context. This section should include current status of pertinent jobs and their pay, your internal consistency analysis, as well as relevant external data (the market rate data given to you) and considered when formulating your proposal. Avoid the urge to insert and explain your proposed changes and rationale here. Save that discussion for the appropriate sections of the memo. 3. Proposed changes to jobs and compensation structure. Any changes to job descriptions, pay grades, and pay ranges should be included here. Avoid the urge to restate the facts and data or explain your rationale here. Keep those discussions in their appropriate sections. 4. Rationale for your proposal. In this section, explain to the president the rationale behind each key feature of your proposal. Tie your proposed changes to resolving the specific problems cited in your introduction. You must also be candid about potential challenges the company will face, as a result of your proposal. Suggest solutions for minimizing the negative impact. 5. Finally, your rationale section should include a plan for implementing your proposal for new and existing employees. Consider how your changes will apply to existing employee pay? Are you suggesting immediate changes? Phased in changes? What is your timeframe? Columbus Custom Carpentry - Compensation System Proposal Memo Template (forced copy) Stay focused on what you have been asked to do. Don’t get distracted by irrelevant details. Focus on base pay. Incentive pay recommendations should be saved for your Incentive Pay memo – Week 7. Keep your reader (the president of the company) in mind as you write your memo. Make it easy for him to grasp the information and the changes you are recommending. HINT: visuals. This assignment is ripe for charts/tables/graphs to illustrate data and make comparisons. Assignment Rubric Excellence System Rubric Submit by Day 7, 11:59pm ET. Review the Course Calendar for specific due dates for this assignment. **The presentation component of this assignment is due next week, which is a shorter week. It is recommended that you start preparing for it now in order to have it completed by the due date.